package sgi.message;
/** message of inserting subscription row image_pack subscription of the username who requested a subscription */
@SuppressWarnings("serial")
public class MessageImagePack extends Message {
	private String UserName;
	private String QImagePack;
	private boolean valid;
	private String notif;
	private String qCheckHasSubscription;
	private String qCountSubscriptions;
	private String qHistory;
	
	public MessageImagePack(String UserName) {
		super("select * from customers where username='"+ UserName + "'");
		setqCheckHasSubscription("select COUNT(*) from  image_pack_subscription where username = '"+ UserName + "'");
		this.setUserName(UserName);
		setqCountSubscriptions("select COUNT(subscription_id) from image_pack_subscription");
		setQImagePack("insert into image_pack_subscription values ('"+UserName+"','"+ 200 +"',0)");
		setqHistory("INSERT INTO `sgi`.`history_purchase` (`username`, `description`) VALUES ('"+UserName+"', 'Image pack subscription')");
	}
	public String getUserName() {
		return UserName;
	}
	public void setUserName(String userName) {
		UserName = userName;
	}
	public String getQImagePack() {
		return QImagePack;
	}
	public void setQImagePack(String qImagePack) {
		QImagePack = qImagePack;
	}
	public boolean isValid() {
		return valid;
	}
	public void setValid(boolean valid) {
		this.valid = valid;
	}
	public String getNotif() {
		return notif;
	}
	public void setNotif(String notif) {
		this.notif = notif;
	}
	public String getqCheckHasSubscription() {
		return qCheckHasSubscription;
	}
	public void setqCheckHasSubscription(String qCheckHasSubscription) {
		this.qCheckHasSubscription = qCheckHasSubscription;
	}
	public String getqCountSubscriptions() {
		return qCountSubscriptions;
	}
	public void setqCountSubscriptions(String qCountSubscriptions) {
		this.qCountSubscriptions = qCountSubscriptions;
	}
	
	public String getqHistory() {
		return qHistory;
	}
	public void setqHistory(String qHistory) {
		this.qHistory = qHistory;
	}
}
